FaStudentAY_Proxy

EntityType | Independent
Logical Entity Name | FaStudentAY_Proxy
Default Table Name | FaStudentAY_Proxy
Logical Only | NO
Owner | dbo
Definition |
Note |

FaStudentAY_Proxy Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaStudentAY_ProxyID |  | BIGINT | NO |
TableName |  | VARCHAR(255) | NO |
RecordID |  | INTEGER | NO |
AdEnrollID |  | INTEGER | NO |
Sequence |  | INTEGER | NO |
OldFaPackStatusID |  | INTEGER | NO |
NewFaPackStatusID |  | INTEGER | NO |
OldAdGradeLevelID |  | INTEGER | NO |
NewAdGradeLevelID |  | INTEGER | NO |
OldTuition |  | MONEY(19, 4) | YES |
NewTuition |  | MONEY(19, 4) | YES |
OldBooksSupplies |  | MONEY(19, 4) | YES |
NewBooksSupplies |  | MONEY(19, 4) | YES |
OldRoomBoard |  | MONEY(19, 4) | YES |
NewRoomBoard |  | MONEY(19, 4) | YES |
OldTravel |  | MONEY(19, 4) | YES |
NewTravel |  | MONEY(19, 4) | YES |
OldBankFees |  | MONEY(19, 4) | NO |
NewBankFees |  | MONEY(19, 4) | NO |
OldOtherAmount1 |  | MONEY(19, 4) | YES |
NewOtherAmount1 |  | MONEY(19, 4) | YES |
OldOtherInst1 |  | BIT | NO |
NewOtherInst1 |  | BIT | NO |
OldOtherDescrip1 |  | VARCHAR(40) | YES |
NewOtherDescrip1 |  | VARCHAR(40) | YES |
OldOtherAmount2 |  | MONEY(19, 4) | YES |
NewOtherAmount2 |  | MONEY(19, 4) | YES |
OldOtherInst2 |  | BIT | NO |
NewOtherInst2 |  | BIT | NO |
OldOtherDescrip2 |  | VARCHAR(40) | YES |
NewOtherDescrip2 |  | VARCHAR(40) | YES |
OldOtherAmount3 |  | MONEY(19, 4) | YES |
NewOtherAmount3 |  | MONEY(19, 4) | YES |
OldOtherInst3 |  | BIT | NO |
NewOtherInst3 |  | BIT | NO |
OldOtherDescrip3 |  | VARCHAR(40) | YES |
NewOtherDescrip3 |  | VARCHAR(40) | YES |
OldOtherAmount4 |  | MONEY(19, 4) | YES |
NewOtherAmount4 |  | MONEY(19, 4) | YES |
OldOtherInst4 |  | BIT | NO |
NewOtherInst4 |  | BIT | NO |
OldOtherDescrip4 |  | VARCHAR(40) | YES |
NewOtherDescrip4 |  | VARCHAR(40) | YES |
OldOtherAmount5 |  | MONEY(19, 4) | YES |
NewOtherAmount5 |  | MONEY(19, 4) | YES |
OldOtherInst5 |  | BIT | NO |
NewOtherInst5 |  | BIT | NO |
OldOtherDescrip5 |  | VARCHAR(40) | YES |
NewOtherDescrip5 |  | VARCHAR(40) | YES |
OldOtherAmount6 |  | MONEY(19, 4) | YES |
NewOtherAmount6 |  | MONEY(19, 4) | YES |
OldOtherInst6 |  | BIT | NO |
NewOtherInst6 |  | BIT | NO |
OldOtherDescrip6 |  | VARCHAR(40) | YES |
NewOtherDescrip6 |  | VARCHAR(40) | YES |
OldOtherAmount7 |  | MONEY(19, 4) | YES |
NewOtherAmount7 |  | MONEY(19, 4) | YES |
OldOtherInst7 |  | BIT | NO |
NewOtherInst7 |  | BIT | NO |
OldOtherDescrip7 |  | VARCHAR(40) | YES |
NewOtherDescrip7 |  | VARCHAR(40) | YES |
OldOtherAmount8 |  | MONEY(19, 4) | YES |
NewOtherAmount8 |  | MONEY(19, 4) | YES |
OldOtherInst8 |  | BIT | NO |
NewOtherInst8 |  | BIT | NO |
OldOtherDescrip8 |  | VARCHAR(40) | YES |
NewOtherDescrip8 |  | VARCHAR(40) | YES |
Comment |  | VARCHAR(400) | YES |
UserID |  | INTEGER | NO |
ModFlag |  | CHAR(1) | YES |
NewStartDate |  | DATETIME | YES |
NewEndDate |  | DATETIME | YES |
OldStartDate |  | DATETIME | YES |
OldEndDate |  | DATETIME | YES |
OldAwardYear2FAPackStatusID |  | INTEGER | YES |
NewAwardYear2FAPackStatusID |  | INTEGER | YES |
OldUnsupportedDependent |  | BIT | NO |
NewUnsupportedDependent |  | BIT | NO |
DateAdded |  | DATETIME | NO |
OldExcludeStartDate |  | BIT | YES |
NewExcludeStartDate |  | BIT | YES |
OldExcludeEndDate |  | BIT | YES |
NewExcludeEndDate |  | BIT | YES |
NewCreditHoursInAY |  | NUMERIC(7, 2) | YES |
OldCreditHoursInAY |  | NUMERIC(7, 2) | YES |
NewWeeksInAY |  | NUMERIC(5, 2) | YES |
OldWeeksInAY |  | NUMERIC(5, 2) | YES |
NewIWINAY |  | NUMERIC(4, 1) | YES |
OldIWINAY |  | NUMERIC(4, 1) | YES |
NewIWMonths |  | NUMERIC(4, 1) | YES |
OldIWMonths |  | NUMERIC(4, 1) | YES |
OldFaAutoAwardPopulationConfigurationId |  | INTEGER | YES |
NewFaAutoAwardPopulationConfigurationId |  | INTEGER | YES |

FaStudentAY_Proxy Keys

Key Name | Key Type | Keys
NK_FaStudentAy_Proxy_RecordID | Inversion Entry | RecordID
FaStudentAY_Proxy_FaStudentAY_ProxyID_U_C_IDX | PrimaryKey | FaStudentAY_ProxyID

FaStudentAY_Proxy Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaStudentAY_Proxy Check Constraints

Check Constraint Name | CheckConstraint

FaStudentAY_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaStudentAY_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentAY_Proxy | NO |  |  |

FaStudentAY_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaStudentAY_Proxy Data Movement Rules

Name | Type | Rule Text/Value